
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for box_info
-- ----------------------------
DROP TABLE IF EXISTS `box_info`;
CREATE TABLE `box_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL COMMENT '门店ID',
  `user_name` varchar(64) DEFAULT NULL COMMENT '用户名称--登入用',
  `serial_no` varchar(64) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL COMMENT 'Box密码',
  `box_uid` varchar(64) DEFAULT NULL,
  `box_name` varchar(32) DEFAULT NULL,
  `box_group_id` varchar(64) DEFAULT NULL,
  `box_memo` varchar(64) DEFAULT NULL,
  `base_url` varchar(1024) DEFAULT NULL,
  `signal_url` varchar(1024) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL,
  `delete_flag` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `boxSerialNo` (`serial_no`) USING BTREE,
  KEY `boxUid` (`box_uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1008 DEFAULT CHARSET=utf8 COMMENT='通信模块box信息';

-- ----------------------------
-- Records of box_info
-- ----------------------------
BEGIN;
INSERT INTO `box_info` VALUES (1001, 1001, 'rdkj168', '319017030016', NULL, '23', '北京南湖加油站', '40', NULL, 'http://cs.rdkj168.com/api/', 'http://cs.rdkj168.com/push', 0, '2017-11-20 16:44:58', NULL, 0);
INSERT INTO `box_info` VALUES (1002, 1002, 'rdkj168', '319017030013', NULL, '9', '湖州大港店', '40', NULL, 'http://cs.rdkj168.com/api/', 'http://cs.rdkj168.com/push', 0, '2017-11-27 14:34:10', NULL, 0);
INSERT INTO `box_info` VALUES (1004, 1003, 'rdkj168', '319017030014', NULL, '16', '湖州向阳店', '40', NULL, 'http://cs.rdkj168.com/api/', 'http://cs.rdkj168.com/push', 0, '2018-01-02 17:42:29', NULL, 0);
INSERT INTO `box_info` VALUES (1005, 1004, 'rdkj168', '319017030012', NULL, '19', '湖州南浔站', '40', NULL, 'http://cs.rdkj168.com/api/', 'http://cs.rdkj168.com/push', 0, '2018-02-05 13:40:43', NULL, 0);
INSERT INTO `box_info` VALUES (1006, 1005, 'rdkj168', '334018010020', NULL, '29', '湖州双林站', '40', NULL, 'http://cs.rdkj168.com/api/', 'http://cs.rdkj168.com/push', 0, '2018-02-09 12:48:42', NULL, 0);
INSERT INTO `box_info` VALUES (1007, 1006, 'rdkj168', '334018010019', NULL, '30', '湖州金鸡山站', '40', NULL, 'http://cs.rdkj168.com/api/', 'http://cs.rdkj168.com/push', 0, '2018-02-11 18:53:42', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;